Tabela LServiceTimePatternTimeslot

Definicja tabeli LServiceTimePatternTimeslot

Name

LServiceTimePatternTimeslot

Code

LServiceTimePatternTimeslot

Comment

PL: Przyporzadkowanie uslugi do przedzialu czasowego grafiku
Dodatkowe uslugi (spoza wzorca) przypisane do timeslotu.
EN: Assignement service to a time pattern's time slot
DE: Die Tabelle fur die ergänzenddien Dienste fur die Einlasszeit


Lista kolumn tabeli LServiceTimePatternTimeslot

Name

Code

Duration

Duration

LServiceTimePatternTimeslotID

LServiceTimePatternTimeslotID

ServID

ServID

TimePatternTimeSlotID

TimePatternTimeSlotID

VisitTypeID

VisitTypeID

Main

Main

ReservationLimit

ReservationLimit

AdditionalVisitsCount

AdditionalVisitsCount


Kolumna Duration tabeli LServiceTimePatternTimeslot

Definicja kolumny Duration tabeli LServiceTimePatternTimeslot

Name

Duration

Code

Duration

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LServiceTimePatternTimeslotID tabeli LServiceTimePatternTimeslot

Definicja kolumny LServiceTimePatternTimeslotID tabeli LServiceTimePatternTimeslot

Name

LServiceTimePatternTimeslotID

Code

LServiceTimePatternTimeslotID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli LServiceTimePatternTimeslot

Definicja kolumny ServID tabeli LServiceTimePatternTimeslot

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TimePatternTimeSlotID tabeli LServiceTimePatternTimeslot

Definicja kolumny TimePatternTimeSlotID tabeli LServiceTimePatternTimeslot

Name

TimePatternTimeSlotID

Code

TimePatternTimeSlotID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VisitTypeID tabeli LServiceTimePatternTimeslot

Definicja kolumny VisitTypeID tabeli LServiceTimePatternTimeslot

Name

VisitTypeID

Code

VisitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Main tabeli LServiceTimePatternTimeslot

Definicja kolumny Main tabeli LServiceTimePatternTimeslot

Name

Main

Code

Main

Data Type

NUMBER(5)

Mandatory

No

Comment

Kolumna zawiera informacje, która z uslug na grafiku jest usluga glówna (do wyswietlania w module eKontrahent).


Kolumna ReservationLimit tabeli LServiceTimePatternTimeslot

Definicja kolumny ReservationLimit tabeli LServiceTimePatternTimeslot

Name

ReservationLimit

Code

ReservationLimit

Data Type

NUMBER(10)

Mandatory

No

Comment

Maksymalna ilosc rezerwacji, które mozna wykonac na dana usluge podpieta do przedzialu czasowego grafiku.


Kolumna AdditionalVisitsCount tabeli LServiceTimePatternTimeslot

Definicja kolumny AdditionalVisitsCount tabeli LServiceTimePatternTimeslot

Name

AdditionalVisitsCount

Code

AdditionalVisitsCount

Data Type

NUMBER(10)

Mandatory

No

Comment

Ilosc mozliwych dodatkowych wizyt w grafiku per usluga


Lista kluczy tabeli LServiceTimePatternTimeslot

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServiceTimePatternTimeslot

Definicja klucza Identifier_1 tabeli LServiceTimePatternTimeslot

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment